﻿CREATE TABLE [dbo].[Charging] (
	[id]		  INT		   IDENTITY (1, 1) NOT NULL,
    [UserId]      INT          NULL,
    [TargetId]    INT          NULL,
    [CreateDate]  DATETIME     NULL,
    [PhoneNumber] VARCHAR (11) NULL,
	CONSTRAINT [PK_Chargingid] PRIMARY KEY CLUSTERED ([id] ASC),
    CONSTRAINT [FK_Charging_User] FOREIGN KEY ([TargetId]) REFERENCES [dbo].[User] ([UserId]),
    CONSTRAINT [FK_Charging_User1] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId])
);

